package com.ycw.dao;

import java.util.List;

import org.apache.ibatis.annotations.Param;

import com.ycw.bean.Projects;

import tk.mybatis.mapper.common.Mapper;

public interface ProjectsMapper extends Mapper<Projects> {
	List<Projects> getAllProjects();

	Projects getProjectById(Integer psId);

	// 项目名称、项目发起人、项目状态（ID）、项目分类（ID）
	public List<Projects> getAllProjectAndType(@Param("psName") String psName, @Param("usName") String usName,
			@Param("psType") Integer psType, @Param("pstId") Integer pstId);

	List<Projects> getProjectsByPsName(@Param("psName") String psName);

	public List<Projects> getAllProjectsByPstName(Integer psPstId);

	public List<Projects> getAllProjectsByPsType(String psType);
}